Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	7346
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	39
Duplicate rows (%)	0.5%
Total size in memory	1.1 MiB
Average record size in memory	152.0 B

Variable types

Unsupported	2
Numeric	16

Alerts

Dataset has 39 (0.5%) duplicate rows	Duplicates
`TOTAL_OIL_PROD` is highly overall correlated with `ACRES` and 7 other fields	High correlation
`TOTAL_GAS_PROD` is highly overall correlated with `2020_GAS_PROD` and 5 other fields	High correlation
`ACRES` is highly overall correlated with `TOTAL_OIL_PROD` and 1 other fields	High correlation
`TOTAL_WELLS` is highly overall correlated with `TOTAL_OIL_PROD` and 4 other fields	High correlation
`2020_OIL_PROD` is highly overall correlated with `TOTAL_OIL_PROD` and 5 other fields	High correlation
`2020_OIL_WELLS` is highly overall correlated with `TOTAL_OIL_PROD` and 6 other fields	High correlation
`2020_GAS_PROD` is highly overall correlated with `TOTAL_GAS_PROD` and 5 other fields	High correlation
`2020_GAS_WELLS` is highly overall correlated with `TOTAL_GAS_PROD` and 5 other fields	High correlation
`2021_OIL_PROD` is highly overall correlated with `TOTAL_OIL_PROD` and 5 other fields	High correlation
`2021_OIL_WELLS` is highly overall correlated with `TOTAL_OIL_PROD` and 6 other fields	High correlation
`2021_GAS_PROD` is highly overall correlated with `TOTAL_GAS_PROD` and 5 other fields	High correlation
`2021_GAS_WELLS` is highly overall correlated with `TOTAL_GAS_PROD` and 5 other fields	High correlation
`2022_OIL_PROD` is highly overall correlated with `TOTAL_OIL_PROD` and 5 other fields	High correlation
`2022_OIL_WELLS` is highly overall correlated with `TOTAL_OIL_PROD` and 6 other fields	High correlation
`2022_GAS_PROD` is highly overall correlated with `TOTAL_GAS_PROD` and 5 other fields	High correlation
`2022_GAS_WELLS` is highly overall correlated with `TOTAL_GAS_PROD` and 5 other fields	High correlation
`TOTAL_OIL_PROD` is highly skewed (γ1 = 29.30878156)	Skewed
`TOTAL_GAS_PROD` is highly skewed (γ1 = 83.11992035)	Skewed
`ACRES` is highly skewed (γ1 = 53.96694092)	Skewed
`TOTAL_WELLS` is highly skewed (γ1 = 43.83043239)	Skewed
`2020_OIL_PROD` is highly skewed (γ1 = 22.43657098)	Skewed
`2020_OIL_WELLS` is highly skewed (γ1 = 42.55877372)	Skewed
`2020_GAS_PROD` is highly skewed (γ1 = 75.10351662)	Skewed
`2020_GAS_WELLS` is highly skewed (γ1 = 63.53279499)	Skewed
`2021_OIL_PROD` is highly skewed (γ1 = 21.53532676)	Skewed
`2021_OIL_WELLS` is highly skewed (γ1 = 42.2894771)	Skewed
`2021_GAS_PROD` is highly skewed (γ1 = 75.43178121)	Skewed
`2021_GAS_WELLS` is highly skewed (γ1 = 63.60517581)	Skewed
`2022_OIL_PROD` is highly skewed (γ1 = 21.61944969)	Skewed
`2022_OIL_WELLS` is highly skewed (γ1 = 41.36102384)	Skewed
`2022_GAS_PROD` is highly skewed (γ1 = 75.3717434)	Skewed
`2022_GAS_WELLS` is highly skewed (γ1 = 64.33845093)	Skewed
`PROD_ZONES` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`DISCOVERY` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`TOTAL_OIL_PROD` has 709 (9.7%) zeros	Zeros
`TOTAL_GAS_PROD` has 5549 (75.5%) zeros	Zeros
`ACRES` has 355 (4.8%) zeros	Zeros
`2020_OIL_PROD` has 3447 (46.9%) zeros	Zeros
`2020_OIL_WELLS` has 3447 (46.9%) zeros	Zeros
`2020_GAS_PROD` has 6600 (89.8%) zeros	Zeros
`2020_GAS_WELLS` has 6600 (89.8%) zeros	Zeros
`2021_OIL_PROD` has 3458 (47.1%) zeros	Zeros
`2021_OIL_WELLS` has 3458 (47.1%) zeros	Zeros
`2021_GAS_PROD` has 6620 (90.1%) zeros	Zeros
`2021_GAS_WELLS` has 6620 (90.1%) zeros	Zeros
`2022_OIL_PROD` has 3566 (48.5%) zeros	Zeros
`2022_OIL_WELLS` has 3566 (48.5%) zeros	Zeros
`2022_GAS_PROD` has 6643 (90.4%) zeros	Zeros
`2022_GAS_WELLS` has 6643 (90.4%) zeros	Zeros

Reproduction

Analysis started	2022-12-30 20:41:21.981891
Analysis finished	2022-12-30 20:42:08.006446
Duration	46.02 seconds
Software version	pandas-profiling vv3.6.1
Download configuration	config.json

PROD_ZONES
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	114.8 KiB

DISCOVERY
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	114.8 KiB

TOTAL_OIL_PROD
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	6442
Distinct (%)	87.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	857357.67

Minimum	0
Maximum	3.1542562 × 10⁸
Zeros	709
Zeros (%)	9.7%
Negative	0
Negative (%)	0.0%
Memory size	114.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	6285.5
median	54744.5
Q3	258251.75
95-th percentile	2235490.5
Maximum	3.1542562 × 10⁸
Range	3.1542562 × 10⁸
Interquartile range (IQR)	251966.25

Descriptive statistics

Standard deviation	8178620.1
Coefficient of variation (CV)	9.5393327
Kurtosis	1005.5754
Mean	857357.67
Median Absolute Deviation (MAD)	54559.5
Skewness	29.308782
Sum	6.2981495 × 10⁹
Variance	6.6889827 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	709	9.7%
3988	3	< 0.1%
1232	3	< 0.1%
5070	3	< 0.1%
127	3	< 0.1%
110	3	< 0.1%
326	3	< 0.1%
1124	3	< 0.1%
122	3	< 0.1%
1536	3	< 0.1%
Other values (6432)	6610	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	709	9.7%
4	1	< 0.1%
7	1	< 0.1%
9	1	< 0.1%
10	2	< 0.1%
12	2	< 0.1%
13	1	< 0.1%
18	2	< 0.1%
20	1	< 0.1%
21	2	< 0.1%

Value	Count	Frequency (%)
315425623	1	< 0.1%
312016415	1	< 0.1%
288375292	1	< 0.1%
274796693	1	< 0.1%
165643536	1	< 0.1%
141205891	1	< 0.1%
100681887	1	< 0.1%
90881849	1	< 0.1%
88339149	1	< 0.1%
77181056	1	< 0.1%

TOTAL_GAS_PROD
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	1795
Distinct (%)	24.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5608836.9

Minimum	0
Maximum	2.7037909 × 10¹⁰
Zeros	5549
Zeros (%)	75.5%
Negative	0
Negative (%)	0.0%
Memory size	114.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2646902.2
Maximum	2.7037909 × 10¹⁰
Range	2.7037909 × 10¹⁰
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.1894594 × 10⁸
Coefficient of variation (CV)	56.864898
Kurtosis	7030.3841
Mean	5608836.9
Median Absolute Deviation (MAD)	0
Skewness	83.11992
Sum	4.1202516 × 10¹⁰
Variance	1.0172651 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5549	75.5%
2883	2	< 0.1%
2016	2	< 0.1%
27593	2	< 0.1%
2792717	1	< 0.1%
13419343	1	< 0.1%
276842	1	< 0.1%
105495	1	< 0.1%
6253999	1	< 0.1%
5494507	1	< 0.1%
Other values (1785)	1785	24.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5549	75.5%
4	1	< 0.1%
30	1	< 0.1%
55	1	< 0.1%
64	1	< 0.1%
86	1	< 0.1%
97	1	< 0.1%
143	1	< 0.1%
157	1	< 0.1%
177	1	< 0.1%

Value	Count	Frequency (%)
2.703790933 × 10¹⁰	1	< 0.1%
3596589571	1	< 0.1%
1235684574	1	< 0.1%
896045276	1	< 0.1%
474795069	1	< 0.1%
466349637	1	< 0.1%
422324126	1	< 0.1%
322203561	1	< 0.1%
265121892	1	< 0.1%
248412613	1	< 0.1%

ACRES
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	293
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3872.2448

Minimum	0
Maximum	7350400
Zeros	355
Zeros (%)	4.8%
Negative	0
Negative (%)	0.0%
Memory size	114.8 KiB

Quantile statistics

Minimum	0
5-th percentile	40
Q1	160
median	560
Q3	960
95-th percentile	4380
Maximum	7350400
Range	7350400
Interquartile range (IQR)	800

Descriptive statistics

Standard deviation	109495.07
Coefficient of variation (CV)	28.276898
Kurtosis	3212.2591
Mean	3872.2448
Median Absolute Deviation (MAD)	400
Skewness	53.966941
Sum	28445510
Variance	1.198917 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
160	1876	25.5%
640	1298	17.7%
320	821	11.2%
960	364	5.0%
480	361	4.9%
0	355	4.8%
800	335	4.6%
1120	170	2.3%
1280	146	2.0%
1440	123	1.7%
Other values (283)	1497	20.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	355	4.8%
10	1	< 0.1%
40	31	0.4%
50	1	< 0.1%
80	30	0.4%
100	1	< 0.1%
120	8	0.1%
160	1876	25.5%
170	1	< 0.1%
200	18	0.2%

Value	Count	Frequency (%)
7350400	1	< 0.1%
4377600	1	< 0.1%
3060480	1	< 0.1%
2254080	1	< 0.1%
325760	1	< 0.1%
300960	1	< 0.1%
243840	1	< 0.1%
192000	1	< 0.1%
172160	1	< 0.1%
121440	1	< 0.1%

TOTAL_WELLS
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	323
Distinct (%)	4.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.305745

Minimum	0
Maximum	20840
Zeros	37
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	114.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	8
Q3	20
95-th percentile	94
Maximum	20840
Range	20840
Interquartile range (IQR)	18

Descriptive statistics

Standard deviation	324.83183
Coefficient of variation (CV)	8.9471193
Kurtosis	2488.9845
Mean	36.305745
Median Absolute Deviation (MAD)	6
Skewness	43.830432
Sum	266702
Variance	105515.72
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1112	15.1%
2	689	9.4%
3	510	6.9%
4	428	5.8%
5	307	4.2%
6	290	3.9%
8	261	3.6%
7	249	3.4%
9	225	3.1%
10	188	2.6%
Other values (313)	3087	42.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	37	0.5%
1	1112	15.1%
2	689	9.4%
3	510	6.9%
4	428	5.8%
5	307	4.2%
6	290	3.9%
7	249	3.4%
8	261	3.6%
9	225	3.1%

Value	Count	Frequency (%)
20840	1	< 0.1%
10459	1	< 0.1%
6719	1	< 0.1%
5427	1	< 0.1%
5407	1	< 0.1%
4158	1	< 0.1%
3310	1	< 0.1%
3294	1	< 0.1%
3206	1	< 0.1%
2827	1	< 0.1%

2020_OIL_PROD
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	2585
Distinct (%)	35.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3105.8064

Minimum	0
Maximum	724131
Zeros	3447
Zeros (%)	46.9%
Negative	0
Negative (%)	0.0%
Memory size	114.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	160
Q3	1767.5
95-th percentile	10908
Maximum	724131
Range	724131
Interquartile range (IQR)	1767.5

Descriptive statistics

Standard deviation	17724.923
Coefficient of variation (CV)	5.7070277
Kurtosis	691.54909
Mean	3105.8064
Median Absolute Deviation (MAD)	160
Skewness	22.436571
Sum	22815254
Variance	3.1417291 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3447	46.9%
160	19	0.3%
319	18	0.2%
157	18	0.2%
155	17	0.2%
162	17	0.2%
159	16	0.2%
163	14	0.2%
154	14	0.2%
323	13	0.2%
Other values (2575)	3753	51.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3447	46.9%
1	1	< 0.1%
3	1	< 0.1%
5	2	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	2	< 0.1%
11	2	< 0.1%
14	1	< 0.1%

Value	Count	Frequency (%)
724131	1	< 0.1%
608746	1	< 0.1%
437990	1	< 0.1%
365765	1	< 0.1%
327338	1	< 0.1%
321006	1	< 0.1%
263588	1	< 0.1%
260347	1	< 0.1%
231215	1	< 0.1%
229821	1	< 0.1%

2020_OIL_WELLS
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	146
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.2726654

Minimum	0
Maximum	3944
Zeros	3447
Zeros (%)	46.9%
Negative	0
Negative (%)	0.0%
Memory size	114.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	15
Maximum	3944
Range	3944
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	60.743125
Coefficient of variation (CV)	9.6837822
Kurtosis	2494.6977
Mean	6.2726654
Median Absolute Deviation (MAD)	1
Skewness	42.558774
Sum	46079
Variance	3689.7273
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3447	46.9%
1	1393	19.0%
2	686	9.3%
3	423	5.8%
4	245	3.3%
5	187	2.5%
6	146	2.0%
7	103	1.4%
8	87	1.2%
10	62	0.8%
Other values (136)	567	7.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3447	46.9%
1	1393	19.0%
2	686	9.3%
3	423	5.8%
4	245	3.3%
5	187	2.5%
6	146	2.0%
7	103	1.4%
8	87	1.2%
9	59	0.8%

Value	Count	Frequency (%)
3944	1	< 0.1%
1358	1	< 0.1%
1283	1	< 0.1%
997	1	< 0.1%
974	1	< 0.1%
683	1	< 0.1%
650	1	< 0.1%
606	1	< 0.1%
575	1	< 0.1%
556	1	< 0.1%

2020_GAS_PROD
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	738
Distinct (%)	10.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21076.549

Minimum	0
Maximum	76710262
Zeros	6600
Zeros (%)	89.8%
Negative	0
Negative (%)	0.0%
Memory size	114.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	15190.5
Maximum	76710262
Range	76710262
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	943342.36
Coefficient of variation (CV)	44.757914
Kurtosis	5988.9416
Mean	21076.549
Median Absolute Deviation (MAD)	0
Skewness	75.103517
Sum	1.5482833 × 10⁸
Variance	8.8989481 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6600	89.8%
1293	2	< 0.1%
6302	2	< 0.1%
1408	2	< 0.1%
4757	2	< 0.1%
14548	2	< 0.1%
13053	2	< 0.1%
1376	2	< 0.1%
36	2	< 0.1%
11	2	< 0.1%
Other values (728)	728	9.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6600	89.8%
2	1	< 0.1%
3	1	< 0.1%
5	1	< 0.1%
10	1	< 0.1%
11	2	< 0.1%
22	1	< 0.1%
25	1	< 0.1%
26	1	< 0.1%
36	2	< 0.1%

Value	Count	Frequency (%)
76710262	1	< 0.1%
21371115	1	< 0.1%
12889388	1	< 0.1%
3322798	1	< 0.1%
2877494	1	< 0.1%
1400150	1	< 0.1%
1209335	1	< 0.1%
1014689	1	< 0.1%
964333	1	< 0.1%
943960	1	< 0.1%

2020_GAS_WELLS
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	60
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.6754696

Minimum	0
Maximum	7278
Zeros	6600
Zeros (%)	89.8%
Negative	0
Negative (%)	0.0%
Memory size	114.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	7278
Range	7278
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	97.63318
Coefficient of variation (CV)	36.491978
Kurtosis	4427.8498
Mean	2.6754696
Median Absolute Deviation (MAD)	0
Skewness	63.532795
Sum	19654
Variance	9532.2378
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6600	89.8%
1	276	3.8%
2	116	1.6%
3	68	0.9%
4	44	0.6%
5	41	0.6%
6	28	0.4%
7	23	0.3%
8	16	0.2%
9	12	0.2%
Other values (50)	122	1.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6600	89.8%
1	276	3.8%
2	116	1.6%
3	68	0.9%
4	44	0.6%
5	41	0.6%
6	28	0.4%
7	23	0.3%
8	16	0.2%
9	12	0.2%

Value	Count	Frequency (%)
7278	1	< 0.1%
3395	1	< 0.1%
2128	1	< 0.1%
637	1	< 0.1%
530	1	< 0.1%
232	1	< 0.1%
211	1	< 0.1%
183	1	< 0.1%
155	1	< 0.1%
154	1	< 0.1%

2021_OIL_PROD
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	2617
Distinct (%)	35.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3056.5494

Minimum	0
Maximum	702299
Zeros	3458
Zeros (%)	47.1%
Negative	0
Negative (%)	0.0%
Memory size	114.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	161
Q3	1760
95-th percentile	10536.75
Maximum	702299
Range	702299
Interquartile range (IQR)	1760

Descriptive statistics

Standard deviation	17090.108
Coefficient of variation (CV)	5.5913077
Kurtosis	639.93597
Mean	3056.5494
Median Absolute Deviation (MAD)	161
Skewness	21.535327
Sum	22453412
Variance	2.920718 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3458	47.1%
156	14	0.2%
158	14	0.2%
160	14	0.2%
323	12	0.2%
154	12	0.2%
316	12	0.2%
320	11	0.1%
314	11	0.1%
162	11	0.1%
Other values (2607)	3777	51.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3458	47.1%
3	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
10	4	0.1%
11	1	< 0.1%
12	1	< 0.1%
14	2	< 0.1%
15	2	< 0.1%
17	1	< 0.1%

Value	Count	Frequency (%)
702299	1	< 0.1%
493005	1	< 0.1%
462485	1	< 0.1%
365661	1	< 0.1%
342608	1	< 0.1%
307978	1	< 0.1%
261994	1	< 0.1%
249033	1	< 0.1%
222628	1	< 0.1%
219720	1	< 0.1%

2021_OIL_WELLS
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	139
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.1463381

Minimum	0
Maximum	3889
Zeros	3458
Zeros (%)	47.1%
Negative	0
Negative (%)	0.0%
Memory size	114.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	14
Maximum	3889
Range	3889
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	60.19943
Coefficient of variation (CV)	9.794357
Kurtosis	2455.047
Mean	6.1463381
Median Absolute Deviation (MAD)	1
Skewness	42.289477
Sum	45151
Variance	3623.9714
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3458	47.1%
1	1416	19.3%
2	695	9.5%
3	409	5.6%
4	254	3.5%
5	189	2.6%
6	117	1.6%
7	114	1.6%
9	67	0.9%
8	66	0.9%
Other values (129)	561	7.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3458	47.1%
1	1416	19.3%
2	695	9.5%
3	409	5.6%
4	254	3.5%
5	189	2.6%
6	117	1.6%
7	114	1.6%
8	66	0.9%
9	67	0.9%

Value	Count	Frequency (%)
3889	1	< 0.1%
1375	1	< 0.1%
1315	1	< 0.1%
1018	1	< 0.1%
977	1	< 0.1%
668	1	< 0.1%
638	1	< 0.1%
628	1	< 0.1%
589	1	< 0.1%
577	1	< 0.1%

2021_GAS_PROD
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	721
Distinct (%)	9.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19765.939

Minimum	0
Maximum	72056862
Zeros	6620
Zeros (%)	90.1%
Negative	0
Negative (%)	0.0%
Memory size	114.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	14343.25
Maximum	72056862
Range	72056862
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	884484.28
Coefficient of variation (CV)	44.747901
Kurtosis	6031.372
Mean	19765.939
Median Absolute Deviation (MAD)	0
Skewness	75.431781
Sum	1.4520059 × 10⁸
Variance	7.8231244 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6620	90.1%
43777	2	< 0.1%
2942	2	< 0.1%
22646	2	< 0.1%
6924	2	< 0.1%
55897	2	< 0.1%
41786	2	< 0.1%
10305	1	< 0.1%
18236	1	< 0.1%
59179	1	< 0.1%
Other values (711)	711	9.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6620	90.1%
1	1	< 0.1%
4	1	< 0.1%
6	1	< 0.1%
12	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
25	1	< 0.1%
32	1	< 0.1%
33	1	< 0.1%

Value	Count	Frequency (%)
72056862	1	< 0.1%
19946514	1	< 0.1%
11378674	1	< 0.1%
3286459	1	< 0.1%
2645673	1	< 0.1%
1238971	1	< 0.1%
1084027	1	< 0.1%
1024850	1	< 0.1%
1017172	1	< 0.1%
992857	1	< 0.1%

2021_GAS_WELLS
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	61
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.5997822

Minimum	0
Maximum	7209
Zeros	6620
Zeros (%)	90.1%
Negative	0
Negative (%)	0.0%
Memory size	114.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	7209
Range	7209
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	96.681466
Coefficient of variation (CV)	37.188294
Kurtosis	4434.1976
Mean	2.5997822
Median Absolute Deviation (MAD)	0
Skewness	63.605176
Sum	19098
Variance	9347.3058
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6620	90.1%
1	278	3.8%
2	104	1.4%
3	72	1.0%
4	36	0.5%
5	36	0.5%
6	35	0.5%
7	27	0.4%
11	14	0.2%
9	12	0.2%
Other values (51)	112	1.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6620	90.1%
1	278	3.8%
2	104	1.4%
3	72	1.0%
4	36	0.5%
5	36	0.5%
6	35	0.5%
7	27	0.4%
8	9	0.1%
9	12	0.2%

Value	Count	Frequency (%)
7209	1	< 0.1%
3372	1	< 0.1%
2095	1	< 0.1%
621	1	< 0.1%
529	1	< 0.1%
232	1	< 0.1%
206	1	< 0.1%
173	1	< 0.1%
137	1	< 0.1%
136	1	< 0.1%

2022_OIL_PROD
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	2088
Distinct (%)	28.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1709.8492

Minimum	0
Maximum	406933
Zeros	3566
Zeros (%)	48.5%
Negative	0
Negative (%)	0.0%
Memory size	114.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	146
Q3	970
95-th percentile	5923
Maximum	406933
Range	406933
Interquartile range (IQR)	970

Descriptive statistics

Standard deviation	9388.2567
Coefficient of variation (CV)	5.4906929
Kurtosis	673.93277
Mean	1709.8492
Median Absolute Deviation (MAD)	146
Skewness	21.61945
Sum	12560552
Variance	88139364
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3566	48.5%
161	29	0.4%
159	26	0.4%
158	26	0.4%
162	24	0.3%
320	23	0.3%
160	22	0.3%
157	21	0.3%
318	21	0.3%
156	21	0.3%
Other values (2078)	3567	48.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3566	48.5%
3	2	< 0.1%
4	1	< 0.1%
6	1	< 0.1%
8	3	< 0.1%
13	3	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
24	2	< 0.1%
25	1	< 0.1%

Value	Count	Frequency (%)
406933	1	< 0.1%
255959	1	< 0.1%
212822	1	< 0.1%
193025	1	< 0.1%
176385	1	< 0.1%
172920	1	< 0.1%
150854	1	< 0.1%
133788	1	< 0.1%
129840	1	< 0.1%
129750	1	< 0.1%

2022_OIL_WELLS
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	138
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.8674108

Minimum	0
Maximum	3639
Zeros	3566
Zeros (%)	48.5%
Negative	0
Negative (%)	0.0%
Memory size	114.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	13
Maximum	3639
Range	3639
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	56.906842
Coefficient of variation (CV)	9.6987996
Kurtosis	2363.5849
Mean	5.8674108
Median Absolute Deviation (MAD)	1
Skewness	41.361024
Sum	43102
Variance	3238.3887
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3566	48.5%
1	1374	18.7%
2	704	9.6%
3	385	5.2%
4	262	3.6%
5	164	2.2%
6	126	1.7%
7	108	1.5%
9	65	0.9%
8	59	0.8%
Other values (128)	533	7.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3566	48.5%
1	1374	18.7%
2	704	9.6%
3	385	5.2%
4	262	3.6%
5	164	2.2%
6	126	1.7%
7	108	1.5%
8	59	0.8%
9	65	0.9%

Value	Count	Frequency (%)
3639	1	< 0.1%
1279	1	< 0.1%
1262	1	< 0.1%
1010	1	< 0.1%
931	1	< 0.1%
658	1	< 0.1%
614	1	< 0.1%
582	1	< 0.1%
567	1	< 0.1%
561	1	< 0.1%

2022_GAS_PROD
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	695
Distinct (%)	9.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11065.357

Minimum	0
Maximum	40152740
Zeros	6643
Zeros (%)	90.4%
Negative	0
Negative (%)	0.0%
Memory size	114.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	7748
Maximum	40152740
Range	40152740
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	493039.49
Coefficient of variation (CV)	44.557034
Kurtosis	6023.5201
Mean	11065.357
Median Absolute Deviation (MAD)	0
Skewness	75.371743
Sum	81286112
Variance	2.4308794 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6643	90.4%
3429	3	< 0.1%
4	2	< 0.1%
2	2	< 0.1%
14	2	< 0.1%
3848	2	< 0.1%
3882	2	< 0.1%
6219	2	< 0.1%
2115	2	< 0.1%
2457	1	< 0.1%
Other values (685)	685	9.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6643	90.4%
2	2	< 0.1%
4	2	< 0.1%
6	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%
14	2	< 0.1%
16	1	< 0.1%
31	1	< 0.1%
34	1	< 0.1%

Value	Count	Frequency (%)
40152740	1	< 0.1%
11169613	1	< 0.1%
6297442	1	< 0.1%
2024499	1	< 0.1%
1438308	1	< 0.1%
643336	1	< 0.1%
599745	1	< 0.1%
574015	1	< 0.1%
541418	1	< 0.1%
540458	1	< 0.1%

2022_GAS_WELLS
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	57
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.5397495

Minimum	0
Maximum	7154
Zeros	6643
Zeros (%)	90.4%
Negative	0
Negative (%)	0.0%
Memory size	114.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	7154
Range	7154
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	95.182763
Coefficient of variation (CV)	37.477224
Kurtosis	4541.4502
Mean	2.5397495
Median Absolute Deviation (MAD)	0
Skewness	64.338451
Sum	18657
Variance	9059.7583
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6643	90.4%
1	267	3.6%
2	104	1.4%
3	69	0.9%
4	37	0.5%
6	35	0.5%
7	31	0.4%
5	28	0.4%
8	11	0.1%
9	10	0.1%
Other values (47)	111	1.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6643	90.4%
1	267	3.6%
2	104	1.4%
3	69	0.9%
4	37	0.5%
5	28	0.4%
6	35	0.5%
7	31	0.4%
8	11	0.1%
9	10	0.1%

Value	Count	Frequency (%)
7154	1	< 0.1%
3192	1	< 0.1%
2066	1	< 0.1%
616	1	< 0.1%
532	1	< 0.1%
232	1	< 0.1%
202	1	< 0.1%
165	1	< 0.1%
134	1	< 0.1%
127	1	< 0.1%

Auto

Heatmap
Table

	TOTAL_OIL_PROD	TOTAL_GAS_PROD	ACRES	TOTAL_WELLS	2020_OIL_PROD	2020_OIL_WELLS	2020_GAS_PROD	2020_GAS_WELLS	2021_OIL_PROD	2021_OIL_WELLS	2021_GAS_PROD	2021_GAS_WELLS	2022_OIL_PROD	2022_OIL_WELLS	2022_GAS_PROD	2022_GAS_WELLS
TOTAL_OIL_PROD	1.000	0.049	0.562	0.787	0.717	0.739	0.097	0.099	0.718	0.736	0.099	0.101	0.712	0.726	0.103	0.106
TOTAL_GAS_PROD	0.049	1.000	0.360	0.260	0.005	0.035	0.660	0.660	0.001	0.028	0.651	0.651	0.005	0.028	0.642	0.642
ACRES	0.562	0.360	1.000	0.732	0.374	0.434	0.274	0.277	0.377	0.432	0.273	0.275	0.380	0.426	0.272	0.274
TOTAL_WELLS	0.787	0.260	0.732	1.000	0.476	0.550	0.204	0.208	0.480	0.549	0.205	0.209	0.481	0.541	0.207	0.210
2020_OIL_PROD	0.717	0.005	0.374	0.476	1.000	0.947	0.100	0.101	0.968	0.917	0.100	0.101	0.950	0.910	0.102	0.104
2020_OIL_WELLS	0.739	0.035	0.434	0.550	0.947	1.000	0.112	0.114	0.914	0.952	0.111	0.113	0.901	0.938	0.115	0.117
2020_GAS_PROD	0.097	0.660	0.274	0.204	0.100	0.112	1.000	0.999	0.094	0.105	0.964	0.963	0.097	0.105	0.940	0.938
2020_GAS_WELLS	0.099	0.660	0.277	0.208	0.101	0.114	0.999	1.000	0.096	0.108	0.961	0.961	0.099	0.108	0.936	0.936
2021_OIL_PROD	0.718	0.001	0.377	0.480	0.968	0.914	0.094	0.096	1.000	0.950	0.098	0.099	0.965	0.922	0.100	0.102
2021_OIL_WELLS	0.736	0.028	0.432	0.549	0.917	0.952	0.105	0.108	0.950	1.000	0.108	0.110	0.912	0.949	0.112	0.114
2021_GAS_PROD	0.099	0.651	0.273	0.205	0.100	0.111	0.964	0.961	0.098	0.108	1.000	0.999	0.099	0.107	0.966	0.965
2021_GAS_WELLS	0.101	0.651	0.275	0.209	0.101	0.113	0.963	0.961	0.099	0.110	0.999	1.000	0.101	0.109	0.963	0.964
2022_OIL_PROD	0.712	0.005	0.380	0.481	0.950	0.901	0.097	0.099	0.965	0.912	0.099	0.101	1.000	0.954	0.103	0.105
2022_OIL_WELLS	0.726	0.028	0.426	0.541	0.910	0.938	0.105	0.108	0.922	0.949	0.107	0.109	0.954	1.000	0.112	0.114
2022_GAS_PROD	0.103	0.642	0.272	0.207	0.102	0.115	0.940	0.936	0.100	0.112	0.966	0.963	0.103	0.112	1.000	0.999
2022_GAS_WELLS	0.106	0.642	0.274	0.210	0.104	0.117	0.938	0.936	0.102	0.114	0.965	0.964	0.105	0.114	0.999	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	PROD_ZONES	DISCOVERY	TOTAL_OIL_PROD	TOTAL_GAS_PROD	ACRES	TOTAL_WELLS	2020_OIL_PROD	2020_OIL_WELLS	2020_GAS_PROD	2020_GAS_WELLS	2021_OIL_PROD	2021_OIL_WELLS	2021_GAS_PROD	2021_GAS_WELLS	2022_OIL_PROD	2022_OIL_WELLS	2022_GAS_PROD	2022_GAS_WELLS
FIELD_NAME
A&W	LANSING-KANSAS CITY, MARMATON, CHEROKEE, MISSISSIPPIAN	1981-10-01 00:00:00	145594.0	260239.0	1280.0	16	155.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	152.0	1.0	0.0	0.0
ABBYVILLE	LANSING-KANSAS CITY	1927-01-01 00:00:00	1193376.0	0.0	2240.0	49	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
ABBYVILLE NORTHEAST	LANSING-KANSAS CITY	1982-06-01 00:00:00	108964.0	0.0	320.0	4	1465.0	2.0	0.0	0.0	1458.0	2.0	0.0	0.0	777.0	2.0	0.0	0.0
ACRES	MISSISSIPPIAN	1984-02-01 00:00:00	2069.0	770476.0	800.0	5	0.0	0.0	10332.0	2.0	94.0	1.0	12977.0	2.0	0.0	0.0	9299.0	2.0
ACRES SOUTH	MISSISSIPPIAN	1984-02-01 00:00:00	0.0	13499.0	160.0	2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
Acres West	MARMATON, MORROWAN, MISSISSIPPIAN	1984-02-01 00:00:00	4673.0	4005962.0	960.0	9	0.0	0.0	34016.0	4.0	0.0	0.0	33512.0	4.0	0.0	0.0	17887.0	3.0
ADAIR	LANSING-KANSAS CITY, MARMATON, ARBUCKLE	1953-01-01 00:00:00	470535.0	0.0	640.0	24	1461.0	8.0	0.0	0.0	2596.0	8.0	0.0	0.0	1620.0	8.0	0.0	0.0
ADAIR NORTHWEST	LANSING-KANSAS CITY, ARBUCKLE	1985-01-01 00:00:00	29302.0	0.0	160.0	4	480.0	1.0	0.0	0.0	654.0	1.0	0.0	0.0	328.0	1.0	0.0	0.0
ADAIR SOUTHWEST	MARMATON	1956-01-01 00:00:00	17386.0	0.0	560.0	12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
ADAMS	LAYTON, MARMATON, CATTLEMAN, BURGESS, ARBUCKLE	1954-01-01 00:00:00	46176.0	1325132.0	4320.0	28	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0

	PROD_ZONES	DISCOVERY	TOTAL_OIL_PROD	TOTAL_GAS_PROD	ACRES	TOTAL_WELLS	2020_OIL_PROD	2020_OIL_WELLS	2020_GAS_PROD	2020_GAS_WELLS	2021_OIL_PROD	2021_OIL_WELLS	2021_GAS_PROD	2021_GAS_WELLS	2022_OIL_PROD	2022_OIL_WELLS	2022_GAS_PROD	2022_GAS_WELLS
FIELD_NAME
ZUERCHER	LANSING-KANSAS CITY, MISSISSIPPIAN, SIMPSON	1959-07-01 00:00:00	804419.0	232046.0	800.0	23	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
Zurich	SHAWNEE GROUP, LANSING-KANSAS CITY	1935-09-01 00:00:00	1681261.0	0.0	1440.0	48	12989.0	11.0	0.0	0.0	12808.0	11.0	0.0	0.0	7249.0	11.0	0.0	0.0
ZURICH TOWNSITE	SHAWNEE GROUP, LANSING-KANSAS CITY, ARBUCKLE	1944-02-01 00:00:00	1857173.0	0.0	800.0	39	10504.0	11.0	0.0	0.0	9860.0	11.0	0.0	0.0	5442.0	11.0	0.0	0.0
ZURICH TOWNSITE SOUTH	SHAWNEE GROUP, LANSING-KANSAS CITY, ARBUCKLE	1949-01-01 00:00:00	199439.0	0.0	320.0	18	2133.0	1.0	0.0	0.0	2766.0	1.0	0.0	0.0	1142.0	1.0	0.0	0.0
ZURICH TOWNSITE SOUTHEAST	LANSING-KANSAS CITY	1978-07-01 00:00:00	79905.0	0.0	640.0	8	302.0	1.0	0.0	0.0	310.0	1.0	0.0	0.0	304.0	1.0	0.0	0.0
ZURICH TOWNSITE WEST	LANSING-KANSAS CITY, ARBUCKLE	1977-06-01 00:00:00	81493.0	0.0	320.0	15	265.0	1.0	0.0	0.0	324.0	1.0	0.0	0.0	498.0	1.0	0.0	0.0
ZWAHLEN	CHEROKEE	1994-01-01 00:00:00	0.0	81948.0	320.0	13	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
Zweygardt	Lansing-Kansas City	2004-01-01 00:00:00	72842.0	0.0	160.0	4	1428.0	3.0	0.0	0.0	1883.0	3.0	0.0	0.0	1249.0	3.0	0.0	0.0
ZYBA	SIMPSON	1937-10-01 00:00:00	983201.0	0.0	960.0	32	674.0	1.0	0.0	0.0	1030.0	2.0	0.0	0.0	487.0	2.0	0.0	0.0
ZYBA SOUTHWEST	LANSING-KANSAS CITY, SIMPSON	1944-06-01 00:00:00	1897837.0	0.0	800.0	43	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0

Most frequently occurring

	ACRES	TOTAL_WELLS	# duplicates
1	0.0	1	110
7	160.0	1	101
8	160.0	2	44
21	640.0	1	44
0	0.0	0	12
13	320.0	1	11
14	320.0	2	10
2	0.0	2	9
9	160.0	3	9
10	160.0	4	8

Overview

Variables

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring